package housekeeping.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import housekeeping.pojo.WorkerApplication;
import org.apache.ibatis.annotations.Insert;

/**
 * @version 1.0
 * @Author Du
 * @Date 2025/7/7 17:02
 * @注释
 */
/* @Insert("INSERT INTO worker (name,phone) VALUES ('新员工',#{phone})")
    int insertworker(@Param("phone") String phone);*/
public interface WorkerApplicationMapper extends BaseMapper<WorkerApplication> {
    @Insert("INSERT INTO worker_application (worker_id, name, phone, id_card, image, gender, age, address, service_type, work_experience, join_date, worker_status, application_status, review_time, reviewer_id) " +
            " values (#{workerId}, #{name}, #{phone}, #{idCard}, #{image}, #{gender}, #{age}, #{address}, #{serviceType}, #{workExperience}, #{joinDate}, #{workerStatus}, #{applicationStatus}, #{reviewTime}, #{reviewerId})")
    void insertWorkerApplication(WorkerApplication workerApplication);
}
